Text typed in cell not shown completely due to Wrap Text not selected.

Cause:


The 'Wrap Text' option is not selected.

Solution:


Select 'Cells...' from the 'Format' menu, click the 'Alignment' tab, and select the 'Wrap Text' option.